﻿select * from LogisticsPackage inner join Shipment on LogisticsPackage.ShipmentId = Shipment.Id where ([Status] = 70 OR [Status] = 71) AND (UpdatedOnUtc BETWEEN '09/05/2014 00:00:00' and '09/05/2014 23:00:00')